Overview
Brought to you by YData
Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 17182 |
| Missing cells | 17 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.5 MiB |
| Average record size in memory | 212.0 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 13 |
| Categorical | 4 |
Battery_Active_Power_Set_Response has constant value "0.0" | Constant |
FC_Active_Power_FC_END_Set has constant value "40.0" | Constant |
FC_Active_Power_FC_end_Set_Response has constant value "40.0" | Constant |
GE_Active_Power is highly overall correlated with GE_Body_Active_Power and 2 other fields | High correlation |
GE_Body_Active_Power is highly overall correlated with GE_Active_Power and 2 other fields | High correlation |
GE_Body_Active_Power_Set_Response is highly overall correlated with GE_Active_Power and 2 other fields | High correlation |
Inlet_Temperature_of_Chilled_Water is highly overall correlated with Outlet_Temperature | High correlation |
Island_mode_MCCB_AC_Voltage is highly overall correlated with MG-LV-MSB_AC_Voltage and 2 other fields | High correlation |
Island_mode_MCCB_Active_Power is highly overall correlated with GE_Active_Power and 3 other fields | High correlation |
Island_mode_MCCB_Frequency is highly overall correlated with MG-LV-MSB_Frequency | High correlation |
MG-LV-MSB_AC_Voltage is highly overall correlated with Island_mode_MCCB_AC_Voltage and 2 other fields | High correlation |
MG-LV-MSB_Frequency is highly overall correlated with Island_mode_MCCB_Frequency | High correlation |
Outlet_Temperature is highly overall correlated with Inlet_Temperature_of_Chilled_Water | High correlation |
PVPCS_Active_Power is highly overall correlated with Island_mode_MCCB_AC_Voltage and 3 other fields | High correlation |
Receiving_Point_AC_Voltage is highly overall correlated with Island_mode_MCCB_AC_Voltage and 2 other fields | High correlation |
FC_Active_Power is highly imbalanced (68.4%) | Imbalance |
Timestamp has unique values | Unique |
Battery_Active_Power has 3892 (22.7%) zeros | Zeros |
PVPCS_Active_Power has 8700 (50.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-03-01 02:44:11.957657 |
|---|---|
| Analysis finished | 2025-03-01 02:44:49.928241 |
| Duration | 37.97 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Timestamp
Text
Unique
| Distinct | 17182 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 18.99936 |
| Min length | 8 |
Unique
| Unique | 17182 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 2023/04/01 00:00:01 |
|---|---|
| 2nd row | 2023/04/01 00:00:11 |
| 3rd row | 2023/04/01 00:00:21 |
| 4th row | 2023/04/01 00:00:31 |
| 5th row | 2023/04/01 00:00:41 |
| Value | Count | Frequency (%) |
| 2023/04/01 | 8640 | |
| 2023/04/02 | 8541 | |
| 23:42:11 | 2 | < 0.1% |
| 23:41:11 | 2 | < 0.1% |
| 23:41:21 | 2 | < 0.1% |
| 23:41:31 | 2 | < 0.1% |
| 23:41:41 | 2 | < 0.1% |
| 23:41:51 | 2 | < 0.1% |
| 23:42:01 | 2 | < 0.1% |
| 23:42:21 | 2 | < 0.1% |
| Other values (8633) | 17166 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 68371 | |
| 2 | 55312 | |
| 1 | 42647 | |
| / | 34364 | |
| : | 34362 | |
| 3 | 26705 | 8.2% |
| 4 | 26042 | 8.0% |
| 17181 | 5.3% | |
| 5 | 8839 | 2.7% |
| 7 | 3156 | 1.0% |
| Other values (3) | 9468 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 326447 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 68371 | |
| 2 | 55312 | |
| 1 | 42647 | |
| / | 34364 | |
| : | 34362 | |
| 3 | 26705 | 8.2% |
| 4 | 26042 | 8.0% |
| 17181 | 5.3% | |
| 5 | 8839 | 2.7% |
| 7 | 3156 | 1.0% |
| Other values (3) | 9468 | 2.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 326447 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 68371 | |
| 2 | 55312 | |
| 1 | 42647 | |
| / | 34364 | |
| : | 34362 | |
| 3 | 26705 | 8.2% |
| 4 | 26042 | 8.0% |
| 17181 | 5.3% | |
| 5 | 8839 | 2.7% |
| 7 | 3156 | 1.0% |
| Other values (3) | 9468 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 326447 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 68371 | |
| 2 | 55312 | |
| 1 | 42647 | |
| / | 34364 | |
| : | 34362 | |
| 3 | 26705 | 8.2% |
| 4 | 26042 | 8.0% |
| 17181 | 5.3% | |
| 5 | 8839 | 2.7% |
| 7 | 3156 | 1.0% |
| Other values (3) | 9468 | 2.9% |
Battery_Active_Power
Real number (ℝ)
Zeros
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.10261335 |
| Minimum | -0.4 |
|---|---|
| Maximum | 0.2 |
| Zeros | 3892 |
| Zeros (%) | 22.7% |
| Negative | 11325 |
| Negative (%) | 65.9% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | -0.4 |
|---|---|
| 5-th percentile | -0.3 |
| Q1 | -0.2 |
| median | -0.1 |
| Q3 | 0 |
| 95-th percentile | 0.1 |
| Maximum | 0.2 |
| Range | 0.6 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.12152328 |
|---|---|
| Coefficient of variation (CV) | -1.1842833 |
| Kurtosis | -0.63780945 |
| Mean | -0.10261335 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | -0.05201605 |
| Sum | -1763 |
| Variance | 0.014767908 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| -0.1 | 5324 | |
| 0 | 3892 | |
| -0.2 | 3843 | |
| -0.3 | 1987 | 11.6% |
| 0.1 | 1903 | 11.1% |
| -0.4 | 171 | 1.0% |
| 0.2 | 61 | 0.4% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -0.4 | 171 | 1.0% |
| -0.3 | 1987 | 11.6% |
| -0.2 | 3843 | |
| -0.1 | 5324 | |
| 0 | 3892 | |
| 0.1 | 1903 | 11.1% |
| 0.2 | 61 | 0.4% |
| Value | Count | Frequency (%) |
| 0.2 | 61 | 0.4% |
| 0.1 | 1903 | 11.1% |
| 0 | 3892 | |
| -0.1 | 5324 | |
| -0.2 | 3843 | |
| -0.3 | 1987 | 11.6% |
| -0.4 | 171 | 1.0% |
Battery_Active_Power_Set_Response
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 1006.9 KiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 17181 | |
| (Missing) | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 17181 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| . | 17181 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 51543 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| . | 17181 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 51543 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| . | 17181 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 51543 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| . | 17181 |
PVPCS_Active_Power
Real number (ℝ)
High correlation Zeros
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.384145 |
| Minimum | -1 |
|---|---|
| Maximum | 47 |
| Zeros | 8700 |
| Zeros (%) | 50.6% |
| Negative | 116 |
| Negative (%) | 0.7% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 30 |
| 95-th percentile | 44 |
| Maximum | 47 |
| Range | 48 |
| Interquartile range (IQR) | 30 |
Descriptive statistics
| Standard deviation | 16.967103 |
|---|---|
| Coefficient of variation (CV) | 1.2677016 |
| Kurtosis | -1.087904 |
| Mean | 13.384145 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.77509939 |
| Sum | 229953 |
| Variance | 287.88258 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=49)
| Value | Count | Frequency (%) |
| 0 | 8700 | |
| 44 | 848 | 4.9% |
| 43 | 550 | 3.2% |
| 42 | 358 | 2.1% |
| 40 | 291 | 1.7% |
| 45 | 264 | 1.5% |
| 41 | 263 | 1.5% |
| 39 | 240 | 1.4% |
| 38 | 240 | 1.4% |
| 1 | 178 | 1.0% |
| Other values (39) | 5249 |
| Value | Count | Frequency (%) |
| -1 | 116 | 0.7% |
| 0 | 8700 | |
| 1 | 178 | 1.0% |
| 2 | 168 | 1.0% |
| 3 | 106 | 0.6% |
| 4 | 140 | 0.8% |
| 5 | 158 | 0.9% |
| 6 | 147 | 0.9% |
| 7 | 154 | 0.9% |
| 8 | 117 | 0.7% |
| Value | Count | Frequency (%) |
| 47 | 5 | < 0.1% |
| 46 | 5 | < 0.1% |
| 45 | 264 | 1.5% |
| 44 | 848 | |
| 43 | 550 | |
| 42 | 358 | |
| 41 | 263 | 1.5% |
| 40 | 291 | 1.7% |
| 39 | 240 | 1.4% |
| 38 | 240 | 1.4% |
GE_Body_Active_Power
Real number (ℝ)
High correlation
| Distinct | 177 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 135.43711 |
| Minimum | 12 |
|---|---|
| Maximum | 227 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 108 |
| Q1 | 118 |
| median | 126 |
| Q3 | 145 |
| 95-th percentile | 200 |
| Maximum | 227 |
| Range | 215 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 27.624361 |
|---|---|
| Coefficient of variation (CV) | 0.20396449 |
| Kurtosis | 1.0689151 |
| Mean | 135.43711 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 1.2841774 |
| Sum | 2326945 |
| Variance | 763.10531 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 123 | 606 | 3.5% |
| 120 | 576 | 3.4% |
| 122 | 564 | 3.3% |
| 119 | 547 | 3.2% |
| 125 | 531 | 3.1% |
| 124 | 522 | 3.0% |
| 126 | 515 | 3.0% |
| 121 | 499 | 2.9% |
| 129 | 486 | 2.8% |
| 127 | 475 | 2.8% |
| Other values (167) | 11860 |
| Value | Count | Frequency (%) |
| 12 | 1 | |
| 35 | 1 | |
| 36 | 1 | |
| 41 | 2 | |
| 47 | 1 | |
| 49 | 1 | |
| 50 | 1 | |
| 51 | 1 | |
| 53 | 1 | |
| 54 | 1 |
| Value | Count | Frequency (%) |
| 227 | 1 | < 0.1% |
| 225 | 2 | < 0.1% |
| 224 | 1 | < 0.1% |
| 223 | 2 | < 0.1% |
| 222 | 5 | < 0.1% |
| 221 | 10 | |
| 220 | 3 | < 0.1% |
| 219 | 15 | |
| 218 | 13 | |
| 217 | 12 |
GE_Active_Power
Real number (ℝ)
High correlation
| Distinct | 728 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 133.19535 |
| Minimum | -21.5 |
|---|---|
| Maximum | 238.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 10 |
| Negative (%) | 0.1% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | -21.5 |
|---|---|
| 5-th percentile | 94.300003 |
| Q1 | 112 |
| median | 128.8 |
| Q3 | 146 |
| 95-th percentile | 198.3 |
| Maximum | 238.8 |
| Range | 260.3 |
| Interquartile range (IQR) | 34 |
Descriptive statistics
| Standard deviation | 30.781072 |
|---|---|
| Coefficient of variation (CV) | 0.23109719 |
| Kurtosis | 0.86180118 |
| Mean | 133.19535 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 0.66070883 |
| Sum | 2288429.3 |
| Variance | 947.47436 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 127.300003 | 115 | 0.7% |
| 123.800003 | 109 | 0.6% |
| 128.800003 | 101 | 0.6% |
| 130.300003 | 100 | 0.6% |
| 133.5 | 100 | 0.6% |
| 126.300003 | 99 | 0.6% |
| 125.300003 | 98 | 0.6% |
| 131 | 97 | 0.6% |
| 128 | 97 | 0.6% |
| 126 | 97 | 0.6% |
| Other values (718) | 16168 |
| Value | Count | Frequency (%) |
| -21.5 | 1 | |
| -19.5 | 1 | |
| -16.5 | 1 | |
| -7.7 | 2 | |
| -4 | 1 | |
| -3.2 | 1 | |
| -1 | 1 | |
| -0.5 | 1 | |
| -0.2 | 1 | |
| 3.8 | 1 |
| Value | Count | Frequency (%) |
| 238.800003 | 1 | |
| 238 | 1 | |
| 234.5 | 1 | |
| 233.800003 | 2 | |
| 233.5 | 1 | |
| 232.300003 | 1 | |
| 231.800003 | 1 | |
| 231 | 1 | |
| 230.800003 | 1 | |
| 230.5 | 1 |
GE_Body_Active_Power_Set_Response
Real number (ℝ)
High correlation
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 136.36813 |
| Minimum | 122 |
|---|---|
| Maximum | 200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 122 |
|---|---|
| 5-th percentile | 122 |
| Q1 | 122 |
| median | 122 |
| Q3 | 155 |
| 95-th percentile | 200 |
| Maximum | 200 |
| Range | 78 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 25.954736 |
|---|---|
| Coefficient of variation (CV) | 0.19032846 |
| Kurtosis | 1.2857402 |
| Mean | 136.36813 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.6414227 |
| Sum | 2342940.8 |
| Variance | 673.6483 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 122 | 12401 | |
| 155 | 2726 | 15.9% |
| 200 | 1980 | 11.5% |
| 152.5 | 21 | 0.1% |
| 181.300003 | 21 | 0.1% |
| 144 | 11 | 0.1% |
| 134 | 10 | 0.1% |
| 149 | 6 | < 0.1% |
| 127 | 3 | < 0.1% |
| 140 | 2 | < 0.1% |
| (Missing) | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 122 | 12401 | |
| 127 | 3 | < 0.1% |
| 134 | 10 | 0.1% |
| 140 | 2 | < 0.1% |
| 144 | 11 | 0.1% |
| 149 | 6 | < 0.1% |
| 152.5 | 21 | 0.1% |
| 155 | 2726 | 15.9% |
| 181.300003 | 21 | 0.1% |
| 200 | 1980 | 11.5% |
| Value | Count | Frequency (%) |
| 200 | 1980 | 11.5% |
| 181.300003 | 21 | 0.1% |
| 155 | 2726 | 15.9% |
| 152.5 | 21 | 0.1% |
| 149 | 6 | < 0.1% |
| 144 | 11 | 0.1% |
| 140 | 2 | < 0.1% |
| 134 | 10 | 0.1% |
| 127 | 3 | < 0.1% |
| 122 | 12401 |
FC_Active_Power_FC_END_Set
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 1023.7 KiB |
| 40.0 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 40.0 |
|---|---|
| 2nd row | 40.0 |
| 3rd row | 40.0 |
| 4th row | 40.0 |
| 5th row | 40.0 |
Common Values
| Value | Count | Frequency (%) |
| 40.0 | 17181 | |
| (Missing) | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 40.0 | 17181 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| 4 | 17181 | |
| . | 17181 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| 4 | 17181 | |
| . | 17181 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| 4 | 17181 | |
| . | 17181 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| 4 | 17181 | |
| . | 17181 |
FC_Active_Power
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 1023.7 KiB |
| 38.0 | |
|---|---|
| 37.0 | 982 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 38.0 |
|---|---|
| 2nd row | 38.0 |
| 3rd row | 38.0 |
| 4th row | 38.0 |
| 5th row | 38.0 |
Common Values
| Value | Count | Frequency (%) |
| 38.0 | 16199 | |
| 37.0 | 982 | 5.7% |
| (Missing) | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 38.0 | 16199 | |
| 37.0 | 982 | 5.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 17181 | |
| . | 17181 | |
| 0 | 17181 | |
| 8 | 16199 | |
| 7 | 982 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 17181 | |
| . | 17181 | |
| 0 | 17181 | |
| 8 | 16199 | |
| 7 | 982 | 1.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 17181 | |
| . | 17181 | |
| 0 | 17181 | |
| 8 | 16199 | |
| 7 | 982 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 17181 | |
| . | 17181 | |
| 0 | 17181 | |
| 8 | 16199 | |
| 7 | 982 | 1.4% |
FC_Active_Power_FC_end_Set_Response
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 1023.7 KiB |
| 40.0 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 40.0 |
|---|---|
| 2nd row | 40.0 |
| 3rd row | 40.0 |
| 4th row | 40.0 |
| 5th row | 40.0 |
Common Values
| Value | Count | Frequency (%) |
| 40.0 | 17181 | |
| (Missing) | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 40.0 | 17181 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| 4 | 17181 | |
| . | 17181 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| 4 | 17181 | |
| . | 17181 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| 4 | 17181 | |
| . | 17181 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 68724 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 34362 | |
| 4 | 17181 | |
| . | 17181 |
Island_mode_MCCB_Active_Power
Real number (ℝ)
High correlation
| Distinct | 173 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -154.33438 |
| Minimum | -232 |
|---|---|
| Maximum | -27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 17181 |
| Negative (%) | > 99.9% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | -232 |
|---|---|
| 5-th percentile | -208 |
| Q1 | -176 |
| median | -145 |
| Q3 | -129 |
| 95-th percentile | -119 |
| Maximum | -27 |
| Range | 205 |
| Interquartile range (IQR) | 47 |
Descriptive statistics
| Standard deviation | 30.131338 |
|---|---|
| Coefficient of variation (CV) | -0.19523413 |
| Kurtosis | -0.76051586 |
| Mean | -154.33438 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | -0.4862299 |
| Sum | -2651619 |
| Variance | 907.89755 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -130 | 442 | 2.6% |
| -127 | 430 | 2.5% |
| -131 | 430 | 2.5% |
| -126 | 422 | 2.5% |
| -129 | 420 | 2.4% |
| -128 | 409 | 2.4% |
| -125 | 383 | 2.2% |
| -132 | 379 | 2.2% |
| -133 | 374 | 2.2% |
| -134 | 371 | 2.2% |
| Other values (163) | 13121 |
| Value | Count | Frequency (%) |
| -232 | 1 | < 0.1% |
| -229 | 4 | < 0.1% |
| -228 | 2 | < 0.1% |
| -227 | 3 | < 0.1% |
| -226 | 4 | < 0.1% |
| -225 | 12 | |
| -224 | 10 | |
| -223 | 15 | |
| -222 | 14 | |
| -221 | 21 |
| Value | Count | Frequency (%) |
| -27 | 1 | |
| -32 | 1 | |
| -44 | 1 | |
| -48 | 1 | |
| -49 | 1 | |
| -50 | 1 | |
| -52 | 1 | |
| -53 | 1 | |
| -54 | 1 | |
| -55 | 2 |
MG-LV-MSB_AC_Voltage
Real number (ℝ)
High correlation
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 486.89098 |
| Minimum | 478 |
|---|---|
| Maximum | 493 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 478 |
|---|---|
| 5-th percentile | 483 |
| Q1 | 485 |
| median | 487 |
| Q3 | 489 |
| 95-th percentile | 490 |
| Maximum | 493 |
| Range | 15 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.3660237 |
|---|---|
| Coefficient of variation (CV) | 0.0048594528 |
| Kurtosis | -0.76025754 |
| Mean | 486.89098 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.2821708 |
| Sum | 8365274 |
| Variance | 5.5980683 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 489 | 3558 | |
| 488 | 2408 | |
| 487 | 2140 | |
| 486 | 2039 | |
| 485 | 1900 | |
| 484 | 1510 | |
| 490 | 1271 | 7.4% |
| 483 | 1110 | 6.5% |
| 482 | 553 | 3.2% |
| 491 | 506 | 2.9% |
| Other values (5) | 186 | 1.1% |
| Value | Count | Frequency (%) |
| 478 | 1 | < 0.1% |
| 480 | 1 | < 0.1% |
| 481 | 52 | 0.3% |
| 482 | 553 | 3.2% |
| 483 | 1110 | |
| 484 | 1510 | |
| 485 | 1900 | |
| 486 | 2039 | |
| 487 | 2140 | |
| 488 | 2408 |
| Value | Count | Frequency (%) |
| 493 | 8 | < 0.1% |
| 492 | 124 | 0.7% |
| 491 | 506 | 2.9% |
| 490 | 1271 | 7.4% |
| 489 | 3558 | |
| 488 | 2408 | |
| 487 | 2140 | |
| 486 | 2039 | |
| 485 | 1900 | |
| 484 | 1510 |
Receiving_Point_AC_Voltage
Real number (ℝ)
High correlation
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 484.51621 |
| Minimum | 475 |
|---|---|
| Maximum | 491 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 475 |
|---|---|
| 5-th percentile | 480 |
| Q1 | 482 |
| median | 485 |
| Q3 | 487 |
| 95-th percentile | 488 |
| Maximum | 491 |
| Range | 16 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.5288871 |
|---|---|
| Coefficient of variation (CV) | 0.0052194065 |
| Kurtosis | -0.83090238 |
| Mean | 484.51621 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.23827579 |
| Sum | 8324473 |
| Variance | 6.3952698 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 487 | 3019 | |
| 486 | 2458 | |
| 485 | 2053 | |
| 484 | 2009 | |
| 482 | 1785 | |
| 483 | 1679 | |
| 481 | 1327 | |
| 488 | 1107 | 6.4% |
| 480 | 939 | 5.5% |
| 489 | 392 | 2.3% |
| Other values (5) | 413 | 2.4% |
| Value | Count | Frequency (%) |
| 475 | 1 | < 0.1% |
| 478 | 7 | < 0.1% |
| 479 | 268 | 1.6% |
| 480 | 939 | 5.5% |
| 481 | 1327 | |
| 482 | 1785 | |
| 483 | 1679 | |
| 484 | 2009 | |
| 485 | 2053 | |
| 486 | 2458 |
| Value | Count | Frequency (%) |
| 491 | 10 | 0.1% |
| 490 | 127 | 0.7% |
| 489 | 392 | 2.3% |
| 488 | 1107 | 6.4% |
| 487 | 3019 | |
| 486 | 2458 | |
| 485 | 2053 | |
| 484 | 2009 | |
| 483 | 1679 | |
| 482 | 1785 |
Island_mode_MCCB_AC_Voltage
Real number (ℝ)
High correlation
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 486.86852 |
| Minimum | 481 |
|---|---|
| Maximum | 493 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 481 |
|---|---|
| 5-th percentile | 483 |
| Q1 | 485 |
| median | 487 |
| Q3 | 489 |
| 95-th percentile | 490 |
| Maximum | 493 |
| Range | 12 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.3699464 |
|---|---|
| Coefficient of variation (CV) | 0.004867734 |
| Kurtosis | -0.77399886 |
| Mean | 486.86852 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.27639483 |
| Sum | 8364888 |
| Variance | 5.6166462 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 489 | 3548 | |
| 488 | 2412 | |
| 487 | 2123 | |
| 486 | 2053 | |
| 485 | 1902 | |
| 484 | 1510 | |
| 490 | 1243 | 7.2% |
| 483 | 1146 | 6.7% |
| 482 | 560 | 3.3% |
| 491 | 494 | 2.9% |
| Other values (3) | 190 | 1.1% |
| Value | Count | Frequency (%) |
| 481 | 60 | 0.3% |
| 482 | 560 | 3.3% |
| 483 | 1146 | 6.7% |
| 484 | 1510 | |
| 485 | 1902 | |
| 486 | 2053 | |
| 487 | 2123 | |
| 488 | 2412 | |
| 489 | 3548 | |
| 490 | 1243 | 7.2% |
| Value | Count | Frequency (%) |
| 493 | 9 | 0.1% |
| 492 | 121 | 0.7% |
| 491 | 494 | 2.9% |
| 490 | 1243 | 7.2% |
| 489 | 3548 | |
| 488 | 2412 | |
| 487 | 2123 | |
| 486 | 2053 | |
| 485 | 1902 | |
| 484 | 1510 |
Island_mode_MCCB_Frequency
Real number (ℝ)
High correlation
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.999576 |
| Minimum | 59.919998 |
|---|---|
| Maximum | 60.07 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 59.919998 |
|---|---|
| 5-th percentile | 59.959999 |
| Q1 | 59.990002 |
| median | 60 |
| Q3 | 60.009998 |
| 95-th percentile | 60.029999 |
| Maximum | 60.07 |
| Range | 0.150002 |
| Interquartile range (IQR) | 0.019996 |
Descriptive statistics
| Standard deviation | 0.020594882 |
|---|---|
| Coefficient of variation (CV) | 0.00034325046 |
| Kurtosis | 0.065120624 |
| Mean | 59.999576 |
| Median Absolute Deviation (MAD) | 0.009998 |
| Skewness | -0.27387404 |
| Sum | 1030852.7 |
| Variance | 0.00042414917 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 60 | 3298 | |
| 60.009998 | 3205 | |
| 59.990002 | 2830 | |
| 60.02 | 2323 | |
| 59.98 | 1819 | |
| 60.029999 | 1140 | 6.6% |
| 59.970001 | 1100 | 6.4% |
| 59.959999 | 593 | 3.5% |
| 60.040001 | 350 | 2.0% |
| 59.950001 | 262 | 1.5% |
| Other values (6) | 261 | 1.5% |
| Value | Count | Frequency (%) |
| 59.919998 | 5 | < 0.1% |
| 59.93 | 20 | 0.1% |
| 59.939999 | 89 | 0.5% |
| 59.950001 | 262 | 1.5% |
| 59.959999 | 593 | 3.5% |
| 59.970001 | 1100 | 6.4% |
| 59.98 | 1819 | |
| 59.990002 | 2830 | |
| 60 | 3298 | |
| 60.009998 | 3205 |
| Value | Count | Frequency (%) |
| 60.07 | 2 | < 0.1% |
| 60.060001 | 25 | 0.1% |
| 60.049999 | 120 | 0.7% |
| 60.040001 | 350 | 2.0% |
| 60.029999 | 1140 | 6.6% |
| 60.02 | 2323 | |
| 60.009998 | 3205 | |
| 60 | 3298 | |
| 59.990002 | 2830 | |
| 59.98 | 1819 |
MG-LV-MSB_Frequency
Real number (ℝ)
High correlation
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59.99953 |
| Minimum | 59.919998 |
|---|---|
| Maximum | 60.07 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 59.919998 |
|---|---|
| 5-th percentile | 59.959999 |
| Q1 | 59.990002 |
| median | 60 |
| Q3 | 60.009998 |
| 95-th percentile | 60.029999 |
| Maximum | 60.07 |
| Range | 0.150002 |
| Interquartile range (IQR) | 0.019996 |
Descriptive statistics
| Standard deviation | 0.020615373 |
|---|---|
| Coefficient of variation (CV) | 0.00034359224 |
| Kurtosis | 0.027334928 |
| Mean | 59.99953 |
| Median Absolute Deviation (MAD) | 0.009998 |
| Skewness | -0.26700286 |
| Sum | 1030851.9 |
| Variance | 0.00042499361 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 60 | 3254 | |
| 60.009998 | 3150 | |
| 59.990002 | 2813 | |
| 60.02 | 2383 | |
| 59.98 | 1907 | |
| 60.029999 | 1127 | 6.6% |
| 59.970001 | 1090 | 6.3% |
| 59.959999 | 577 | 3.4% |
| 60.040001 | 354 | 2.1% |
| 59.950001 | 262 | 1.5% |
| Other values (6) | 264 | 1.5% |
| Value | Count | Frequency (%) |
| 59.919998 | 3 | < 0.1% |
| 59.93 | 16 | 0.1% |
| 59.939999 | 102 | 0.6% |
| 59.950001 | 262 | 1.5% |
| 59.959999 | 577 | 3.4% |
| 59.970001 | 1090 | 6.3% |
| 59.98 | 1907 | |
| 59.990002 | 2813 | |
| 60 | 3254 | |
| 60.009998 | 3150 |
| Value | Count | Frequency (%) |
| 60.07 | 1 | < 0.1% |
| 60.060001 | 26 | 0.2% |
| 60.049999 | 116 | 0.7% |
| 60.040001 | 354 | 2.1% |
| 60.029999 | 1127 | 6.6% |
| 60.02 | 2383 | |
| 60.009998 | 3150 | |
| 60 | 3254 | |
| 59.990002 | 2813 | |
| 59.98 | 1907 |
Inlet_Temperature_of_Chilled_Water
Real number (ℝ)
High correlation
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.986345 |
| Minimum | 11.8 |
|---|---|
| Maximum | 17 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 11.8 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 13.6 |
| median | 15.3 |
| Q3 | 16.5 |
| 95-th percentile | 16.9 |
| Maximum | 17 |
| Range | 5.2 |
| Interquartile range (IQR) | 2.9 |
Descriptive statistics
| Standard deviation | 1.5940079 |
|---|---|
| Coefficient of variation (CV) | 0.10636402 |
| Kurtosis | -1.129406 |
| Mean | 14.986345 |
| Median Absolute Deviation (MAD) | 1.4 |
| Skewness | -0.4234269 |
| Sum | 257480.4 |
| Variance | 2.5408611 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16.799999 | 1442 | 8.4% |
| 16.9 | 909 | 5.3% |
| 16.700001 | 751 | 4.4% |
| 16.4 | 640 | 3.7% |
| 16.1 | 617 | 3.6% |
| 16.6 | 596 | 3.5% |
| 13.1 | 571 | 3.3% |
| 11.9 | 479 | 2.8% |
| 16.200001 | 474 | 2.8% |
| 15.8 | 459 | 2.7% |
| Other values (43) | 10243 |
| Value | Count | Frequency (%) |
| 11.8 | 240 | |
| 11.9 | 479 | |
| 12 | 147 | 0.9% |
| 12.1 | 139 | 0.8% |
| 12.2 | 199 | |
| 12.3 | 118 | 0.7% |
| 12.4 | 132 | 0.8% |
| 12.5 | 176 | 1.0% |
| 12.6 | 115 | 0.7% |
| 12.7 | 126 | 0.7% |
| Value | Count | Frequency (%) |
| 17 | 307 | 1.8% |
| 16.9 | 909 | |
| 16.799999 | 1442 | |
| 16.700001 | 751 | |
| 16.6 | 596 | |
| 16.5 | 424 | 2.5% |
| 16.4 | 640 | |
| 16.299999 | 342 | 2.0% |
| 16.200001 | 474 | 2.8% |
| 16.1 | 617 |
Outlet_Temperature
Real number (ℝ)
High correlation
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.450864 |
| Minimum | 13.6 |
|---|---|
| Maximum | 16.799999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 134.4 KiB |
Quantile statistics
| Minimum | 13.6 |
|---|---|
| 5-th percentile | 13.8 |
| Q1 | 14.6 |
| median | 15.5 |
| Q3 | 16.4 |
| 95-th percentile | 16.6 |
| Maximum | 16.799999 |
| Range | 3.199999 |
| Interquartile range (IQR) | 1.8 |
Descriptive statistics
| Standard deviation | 0.93656796 |
|---|---|
| Coefficient of variation (CV) | 0.060615894 |
| Kurtosis | -1.1567129 |
| Mean | 15.450864 |
| Median Absolute Deviation (MAD) | 0.9 |
| Skewness | -0.34647068 |
| Sum | 265461.3 |
| Variance | 0.87715955 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=33)
| Value | Count | Frequency (%) |
| 16.5 | 1456 | 8.5% |
| 16.4 | 1278 | 7.4% |
| 14.5 | 1051 | 6.1% |
| 16.6 | 959 | 5.6% |
| 16.1 | 781 | 4.5% |
| 16.700001 | 726 | 4.2% |
| 16.299999 | 667 | 3.9% |
| 15.8 | 661 | 3.8% |
| 13.7 | 654 | 3.8% |
| 15.4 | 620 | 3.6% |
| Other values (23) | 8328 |
| Value | Count | Frequency (%) |
| 13.6 | 147 | 0.9% |
| 13.7 | 654 | |
| 13.8 | 494 | |
| 13.9 | 187 | 1.1% |
| 14 | 174 | 1.0% |
| 14.1 | 294 | 1.7% |
| 14.2 | 215 | 1.3% |
| 14.3 | 213 | 1.2% |
| 14.4 | 572 | |
| 14.5 | 1051 |
| Value | Count | Frequency (%) |
| 16.799999 | 34 | 0.2% |
| 16.700001 | 726 | |
| 16.6 | 959 | |
| 16.5 | 1456 | |
| 16.4 | 1278 | |
| 16.299999 | 667 | |
| 16.200001 | 513 | 3.0% |
| 16.1 | 781 | |
| 16 | 433 | 2.5% |
| 15.9 | 430 | 2.5% |
Interactions
Correlations
| Battery_Active_Power | FC_Active_Power | GE_Active_Power | GE_Body_Active_Power | GE_Body_Active_Power_Set_Response | Inlet_Temperature_of_Chilled_Water | Island_mode_MCCB_AC_Voltage | Island_mode_MCCB_Active_Power | Island_mode_MCCB_Frequency | MG-LV-MSB_AC_Voltage | MG-LV-MSB_Frequency | Outlet_Temperature | PVPCS_Active_Power | Receiving_Point_AC_Voltage | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Battery_Active_Power | 1.000 | 0.028 | -0.023 | -0.036 | -0.049 | -0.132 | -0.068 | -0.027 | -0.015 | -0.067 | -0.012 | -0.131 | 0.109 | -0.067 |
| FC_Active_Power | 0.028 | 1.000 | 0.083 | 0.095 | 0.116 | 0.200 | 0.438 | 0.231 | 0.057 | 0.404 | 0.057 | 0.151 | 0.292 | 0.391 |
| GE_Active_Power | -0.023 | 0.083 | 1.000 | 0.584 | 0.708 | 0.280 | 0.017 | -0.530 | -0.041 | 0.023 | -0.046 | 0.264 | -0.019 | -0.087 |
| GE_Body_Active_Power | -0.036 | 0.095 | 0.584 | 1.000 | 0.772 | 0.287 | 0.006 | -0.622 | -0.099 | 0.014 | -0.109 | 0.269 | 0.017 | -0.114 |
| GE_Body_Active_Power_Set_Response | -0.049 | 0.116 | 0.708 | 0.772 | 1.000 | 0.374 | -0.008 | -0.733 | 0.047 | -0.003 | 0.041 | 0.352 | 0.037 | -0.151 |
| Inlet_Temperature_of_Chilled_Water | -0.132 | 0.200 | 0.280 | 0.287 | 0.374 | 1.000 | 0.036 | -0.019 | 0.071 | 0.037 | 0.072 | 0.996 | -0.377 | 0.018 |
| Island_mode_MCCB_AC_Voltage | -0.068 | 0.438 | 0.017 | 0.006 | -0.008 | 0.036 | 1.000 | 0.324 | -0.049 | 0.990 | -0.049 | 0.055 | -0.623 | 0.973 |
| Island_mode_MCCB_Active_Power | -0.027 | 0.231 | -0.530 | -0.622 | -0.733 | -0.019 | 0.324 | 1.000 | 0.016 | 0.325 | 0.020 | 0.012 | -0.523 | 0.471 |
| Island_mode_MCCB_Frequency | -0.015 | 0.057 | -0.041 | -0.099 | 0.047 | 0.071 | -0.049 | 0.016 | 1.000 | -0.051 | 0.926 | 0.076 | 0.011 | -0.049 |
| MG-LV-MSB_AC_Voltage | -0.067 | 0.404 | 0.023 | 0.014 | -0.003 | 0.037 | 0.990 | 0.325 | -0.051 | 1.000 | -0.050 | 0.057 | -0.623 | 0.973 |
| MG-LV-MSB_Frequency | -0.012 | 0.057 | -0.046 | -0.109 | 0.041 | 0.072 | -0.049 | 0.020 | 0.926 | -0.050 | 1.000 | 0.077 | 0.009 | -0.047 |
| Outlet_Temperature | -0.131 | 0.151 | 0.264 | 0.269 | 0.352 | 0.996 | 0.055 | 0.012 | 0.076 | 0.057 | 0.077 | 1.000 | -0.396 | 0.042 |
| PVPCS_Active_Power | 0.109 | 0.292 | -0.019 | 0.017 | 0.037 | -0.377 | -0.623 | -0.523 | 0.011 | -0.623 | 0.009 | -0.396 | 1.000 | -0.660 |
| Receiving_Point_AC_Voltage | -0.067 | 0.391 | -0.087 | -0.114 | -0.151 | 0.018 | 0.973 | 0.471 | -0.049 | 0.973 | -0.047 | 0.042 | -0.660 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| Timestamp | Battery_Active_Power | Battery_Active_Power_Set_Response | PVPCS_Active_Power | GE_Body_Active_Power | GE_Active_Power | GE_Body_Active_Power_Set_Response | FC_Active_Power_FC_END_Set | FC_Active_Power | FC_Active_Power_FC_end_Set_Response | Island_mode_MCCB_Active_Power | MG-LV-MSB_AC_Voltage | Receiving_Point_AC_Voltage | Island_mode_MCCB_AC_Voltage | Island_mode_MCCB_Frequency | MG-LV-MSB_Frequency | Inlet_Temperature_of_Chilled_Water | Outlet_Temperature | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2023/04/01 00:00:01 | -0.1 | 0.0 | 0.0 | 110.0 | 87.000000 | 122.0 | 40.0 | 38.0 | 40.0 | -123.0 | 488.0 | 486.0 | 488.0 | 60.040001 | 60.040001 | 15.1 | 15.5 |
| 1 | 2023/04/01 00:00:11 | -0.3 | 0.0 | 0.0 | 118.0 | 120.000000 | 122.0 | 40.0 | 38.0 | 40.0 | -87.0 | 488.0 | 486.0 | 488.0 | 60.040001 | 60.040001 | 15.1 | 15.5 |
| 2 | 2023/04/01 00:00:21 | 0.0 | 0.0 | 0.0 | 116.0 | 124.000000 | 122.0 | 40.0 | 38.0 | 40.0 | -116.0 | 488.0 | 486.0 | 488.0 | 60.040001 | 60.040001 | 15.1 | 15.5 |
| 3 | 2023/04/01 00:00:31 | -0.1 | 0.0 | 0.0 | 110.0 | 94.300003 | 122.0 | 40.0 | 38.0 | 40.0 | -115.0 | 488.0 | 486.0 | 488.0 | 60.049999 | 60.049999 | 15.1 | 15.5 |
| 4 | 2023/04/01 00:00:41 | 0.0 | 0.0 | 0.0 | 116.0 | 116.000000 | 122.0 | 40.0 | 38.0 | 40.0 | -128.0 | 488.0 | 486.0 | 488.0 | 60.049999 | 60.049999 | 15.1 | 15.5 |
| 5 | 2023/04/01 00:00:51 | 0.0 | 0.0 | 0.0 | 115.0 | 109.800003 | 122.0 | 40.0 | 38.0 | 40.0 | -109.0 | 488.0 | 486.0 | 488.0 | 60.040001 | 60.040001 | 15.1 | 15.5 |
| 6 | 2023/04/01 00:01:01 | 0.0 | 0.0 | 0.0 | 114.0 | 96.000000 | 122.0 | 40.0 | 38.0 | 40.0 | -115.0 | 488.0 | 486.0 | 488.0 | 60.040001 | 60.029999 | 15.1 | 15.5 |
| 7 | 2023/04/01 00:01:11 | 0.1 | 0.0 | 0.0 | 78.0 | 133.500000 | 122.0 | 40.0 | 38.0 | 40.0 | -98.0 | 487.0 | 486.0 | 487.0 | 60.040001 | 60.060001 | 15.1 | 15.6 |
| 8 | 2023/04/01 00:01:21 | -0.1 | 0.0 | 0.0 | 124.0 | 121.500000 | 122.0 | 40.0 | 38.0 | 40.0 | -125.0 | 488.0 | 486.0 | 488.0 | 60.049999 | 60.049999 | 15.1 | 15.5 |
| 9 | 2023/04/01 00:01:31 | -0.3 | 0.0 | 0.0 | 113.0 | 115.500000 | 122.0 | 40.0 | 38.0 | 40.0 | -119.0 | 487.0 | 485.0 | 488.0 | 60.040001 | 60.029999 | 15.1 | 15.5 |
| Timestamp | Battery_Active_Power | Battery_Active_Power_Set_Response | PVPCS_Active_Power | GE_Body_Active_Power | GE_Active_Power | GE_Body_Active_Power_Set_Response | FC_Active_Power_FC_END_Set | FC_Active_Power | FC_Active_Power_FC_end_Set_Response | Island_mode_MCCB_Active_Power | MG-LV-MSB_AC_Voltage | Receiving_Point_AC_Voltage | Island_mode_MCCB_AC_Voltage | Island_mode_MCCB_Frequency | MG-LV-MSB_Frequency | Inlet_Temperature_of_Chilled_Water | Outlet_Temperature | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17172 | 2023/04/02 23:42:01 | 0.0 | 0.0 | 0.0 | 180.0 | 175.300003 | 200.0 | 40.0 | 38.0 | 40.0 | -204.0 | 489.0 | 486.0 | 489.0 | 60.029999 | 60.020000 | 15.7 | 15.8 |
| 17173 | 2023/04/02 23:42:11 | -0.3 | 0.0 | 0.0 | 223.0 | 168.300003 | 200.0 | 40.0 | 38.0 | 40.0 | -209.0 | 489.0 | 486.0 | 489.0 | 60.020000 | 60.029999 | 15.7 | 15.8 |
| 17174 | 2023/04/02 23:42:21 | -0.3 | 0.0 | 0.0 | 208.0 | 206.300003 | 200.0 | 40.0 | 38.0 | 40.0 | -214.0 | 489.0 | 486.0 | 489.0 | 60.029999 | 60.029999 | 15.7 | 15.8 |
| 17175 | 2023/04/02 23:42:31 | -0.2 | 0.0 | 0.0 | 198.0 | 197.500000 | 200.0 | 40.0 | 38.0 | 40.0 | -207.0 | 489.0 | 486.0 | 489.0 | 60.029999 | 60.029999 | 15.7 | 15.8 |
| 17176 | 2023/04/02 23:42:41 | -0.1 | 0.0 | 0.0 | 197.0 | 193.300003 | 200.0 | 40.0 | 38.0 | 40.0 | -203.0 | 489.0 | 486.0 | 489.0 | 60.029999 | 60.029999 | 15.7 | 15.8 |
| 17177 | 2023/04/02 23:42:51 | 0.1 | 0.0 | 0.0 | 168.0 | 184.300003 | 200.0 | 40.0 | 38.0 | 40.0 | -165.0 | 489.0 | 486.0 | 489.0 | 60.029999 | 60.029999 | 15.7 | 15.8 |
| 17178 | 2023/04/02 23:43:01 | -0.2 | 0.0 | 0.0 | 202.0 | 220.500000 | 200.0 | 40.0 | 38.0 | 40.0 | -187.0 | 489.0 | 486.0 | 489.0 | 60.029999 | 60.020000 | 15.7 | 15.7 |
| 17179 | 2023/04/02 23:43:11 | 0.0 | 0.0 | 0.0 | 205.0 | 211.300003 | 200.0 | 40.0 | 38.0 | 40.0 | -208.0 | 489.0 | 486.0 | 489.0 | 60.029999 | 60.029999 | 15.7 | 15.8 |
| 17180 | 2023/04/02 23:43:21 | -0.1 | 0.0 | 0.0 | 203.0 | 220.500000 | 200.0 | 40.0 | 38.0 | 40.0 | -219.0 | 489.0 | 486.0 | 489.0 | 60.029999 | 60.029999 | 15.7 | 15.7 |
| 17181 | 2023/04/ | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |